﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 首页banner配置实体类：fanli_banner 。
	/// </summary>
	[Serializable]
	public class fanli_banner
	{
		public fanli_banner()
		{}

		#region Model
		private int _id; //id
		private string _title; //名称
		private string _picurl; //图片地址
		private string _gotourl; //链接地址
		private int _sortid; //排序


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 名称
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// 图片地址
		/// </summary>
		public string picurl
		{
			set{ _picurl=value;}
			get{return _picurl;}
		}
        /// <summary>
		/// 链接地址
		/// </summary>
		public string gotourl
		{
			set{ _gotourl=value;}
			get{return _gotourl;}
		}
        /// <summary>
		/// 排序
		/// </summary>
		public int sortid
		{
			set{ _sortid=value;}
			get{return _sortid;}
		}
		#endregion Model

		#region txt document
		/*
首页banner配置,banner
id,名称,图片地址,链接地址,排序
id,title,picurl,gotourl,sortid
i,c100,c256,c256,i



--------------------------
-- 创建表[首页banner配置]开始: 
-- alter table  [fanli_banner] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_banner') drop table fanli_banner
  CREATE TABLE [fanli_banner] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [title] [varchar] (100),
	 [picurl] [varchar] (256),
	 [gotourl] [varchar] (256),
	 [sortid] int
  )

 exec sp_addextendedproperty N'MS_Description',N'首页banner配置 ',N'user',N'dbo',N'table',N'fanli_banner', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_banner',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'名称',N'user',N'dbo',N'table',N'fanli_banner',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'图片地址',N'user',N'dbo',N'table',N'fanli_banner',N'column',N'picurl'
 exec sp_addextendedproperty N'MS_Description',N'链接地址',N'user',N'dbo',N'table',N'fanli_banner',N'column',N'gotourl'
 exec sp_addextendedproperty N'MS_Description',N'排序',N'user',N'dbo',N'table',N'fanli_banner',N'column',N'sortid'

-- 创建表[首页banner配置]结束。 
--------------------------

		*/
		#endregion document
	}
}

